In [1]:
import os
import numpy as np
import pandas as pd 
import plotly
import plotly.express as px
In [ ]:
In [2]:
def temporal_profile(input_dir, grid, index_list):
    for i in index_list:
        input_csv =  input_dir + grid + "_" + i + "_full_TS.csv"
        df = pd.read_csv(input_csv, header=0, index_col=0, parse_dates=True)
        fig = px.line(df, x='Date', y='Value', title= i.upper() + ' Time Series (for plots in grid ' + grid + ")", 
                      color='FieldID', 
                      color_discrete_sequence=px.colors.qualitative.Dark2, # Bold, Vivid, Dark2, Pastel
                      line_dash='Parcela')
        fig.update_layout(xaxis_title='Date', yaxis_title='VI Value')
        fig.update_xaxes(rangeselector=dict(buttons=list([dict(count=6, label="6m", step="month", stepmode="backward"),
                                                          dict(count=1, label="1y", step="year", stepmode="backward"), 
                                                          dict(count=2, label="2y", step="year", stepmode="backward"), 
                                                          dict(step="all")]) ), 
                        rangeslider_visible=True)
        fig.show()
In [3]:
NI_grids = ['002225','002387','002388','002548','002549','002550']
ES_grids = ['001892','001972','002047','002056','002127']
indices = ['evi2', 'kndvi'] #['evi2', 'kndvi', 'gcvi', 'nbr']
input_dir="/home/downspout-cel/wsa_lc/TS/"
#####################################

for i in NI_grids:
    temporal_profile(input_dir="/home/downspout-cel/wsa_lc/TS/", grid=i, index_list=indices)
    practices_csv =  input_dir + "practices_NI_ES.csv"
    practices_df = pd.read_csv(practices_csv, dtype=str) 
    grid_practice_df = practices_df[practices_df['Grid'] == str(i)]
    practices = pd.pivot(grid_practice_df, index=['ID_Prod','Parcela', 'Nom.Cob'], columns=['Temporada','Ano'], values=['Cultivo'])
    display(practices)
Cultivo
Temporada Postrera Primera Postrera Primera Postrera Primera Postrera Primera
Ano 2016 2016 2017 2017 2018 2018 2019 2019
ID_Prod Parcela Nom.Cob
NI_295 ASA maíz-frijol-canavalia Barbecho Maiz Frijol Maiz Frijol Maiz NaN NaN
Testigo no Barbecho Maiz Frijol Maiz Frijol Maiz NaN NaN
NI_307 ASA maíz-frijol-canavalia Frijol Maiz Frijol Maiz Sorgo Maiz None Maiz
Testigo no Frijol Maiz Frijol Maiz Sorgo Maiz None Maiz
NI_313 ASA maíz-frijol-canavalia Sorgo Maiz Frijol Maiz NaN Maiz Sorgo Maiz
Testigo no Sorgo Maiz Frijol Maiz NaN Maiz Sorgo Maiz
NI_385 ASA maíz-frijol-canavalia Frijol Maiz Frijol Maiz Frijol Maiz Frijol Maiz
Testigo no Frijol Maiz Frijol Maiz Frijol Maiz Frijol Maiz
NI_407 ASA maíz-canavalia NaN NaN NaN NaN NaN NaN Tomate NaN
maíz-frijol-canavalia Frijol Maiz Frijol Maiz NaN Maiz NaN Maiz
Testigo no Frijol Maiz Frijol Maiz NaN Maiz Tomate Maiz
Cultivo
Temporada Postrera Primera Postrera Primera Postrera
Ano 2016 2016 2017 2017 2018 2019 2019
ID_Prod Parcela Nom.Cob
NI_248 ASA maíz-canavalia NaN NaN NaN NaN NaN NaN None
maíz-frijol-canavalia Frijol Maiz Frijol Maiz Maiz Maiz NaN
Testigo no Frijol Maiz Frijol Maiz Maiz Maiz None
NI_258 ASA maíz-canavalia NaN NaN NaN NaN NaN NaN None
maíz-frijol-canavalia Frijol Maiz Frijol Maiz Maiz Maiz NaN
Testigo no Frijol Maiz Frijol Maiz Maiz Maiz None
Cultivo
Temporada Postrera Primera Postrera Primera Postrera Primera Postrera Primera
Ano 2016 2016 2017 2017 2018 2018 2019 2019
ID_Prod Parcela Nom.Cob
NI_147 ASA maíz-frijol-canavalia Frijol Maiz Frijol Maiz Frijol Maiz Frijol Frijol
Testigo no Frijol Maiz Frijol Maiz Frijol Maiz Frijol Frijol
NI_192 ASA maíz-frijol-canavalia Frijol Maiz Frijol Maiz Frijol Maiz Frijol Maiz
Testigo no Frijol Maiz Frijol Maiz Frijol Maiz Frijol Maiz
NI_218 ASA maíz-frijol-canavalia Frijol Maiz Frijol Maiz Frijol Maiz Frijol Maiz
Testigo no Frijol Maiz Frijol Maiz Frijol Maiz Frijol Maiz
Cultivo
Temporada Postrera Primera Postrera Primera Postrera Primera Postrera Primera
Ano 2016 2016 2017 2017 2018 2018 2019 2019
ID_Prod Parcela Nom.Cob
NI_480 ASA maíz-frijol-canavalia Frijol Maiz Maiz Frijol Sorgo Frijol Frijol Frijol
Testigo no Frijol Maiz Maiz Frijol Sorgo Frijol Frijol Frijol
NI_660 ASA maíz-frijol-canavalia Frijol Maiz Frijol Maiz Frijol Frijol Frijol Maiz
Testigo no Frijol Maiz Frijol Maiz Frijol Frijol Frijol Maiz
NI_697 ASA maíz-frijol-canavalia Frijol Maiz Frijol Maiz Frijol Frijol Frijol Frijol
Testigo no Frijol Maiz Frijol Maiz Frijol Frijol Frijol Frijol
Cultivo
Temporada Postrera Primera Postrera Primera Postrera Primera Postrera Primera
Ano 2016 2016 2017 2017 2018 2018 2019 2019
ID_Prod Parcela Nom.Cob
NI_470 ASA maíz-frijol-canavalia Maiz Frijol Sorgo Frijol Sorgo Frijol Frijol Maiz
Testigo no Maiz Frijol Sorgo Frijol Sorgo Frijol Frijol Maiz
NI_482 ASA maíz-frijol-canavalia Frijol Maiz Maiz Frijol Frijol Maiz Frijol Maiz
Testigo no Frijol Maiz Maiz Frijol Frijol Maiz Frijol Maiz
NI_599 ASA maíz-frijol-canavalia Frijol Maiz Frijol Frijol Sorgo Frijol Frijol Maiz
Testigo no Frijol Maiz Frijol Frijol Sorgo Frijol Frijol Maiz
NI_634 ASA maíz-frijol-canavalia Sorgo Maiz Maiz Frijol Sorgo Frijol Maiz Frijol
Testigo no Sorgo Maiz Maiz Frijol Sorgo Frijol Maiz Frijol
NI_698 ASA maíz-frijol-canavalia Frijol Maiz Sorgo Frijol Sorgo Maiz Frijol Maiz
Testigo no Frijol Maiz Sorgo Frijol Sorgo Maiz Frijol Maiz
Cultivo
Temporada Postrera Primera Postrera Primera Postrera Primera
Ano 2016 2016 2017 2017 2018 2019 2019
ID_Prod Parcela Nom.Cob
NI_581 ASA maíz-frijol-canavalia Frijol Maiz Frijol Maiz Maiz Frijol Maiz
Testigo no Frijol Maiz Frijol Maiz Maiz Frijol Maiz
In [ ]:
In [ ]:
!jupyter nbconvert --to html CRS_plot_TS.ipynb